Search Results for: "HK MP5 22"

select * from tb_mfg_promo.dbo.tb_search_redirect with (nolock) where kword='HK MP5 22' and kword <> '' and kword is not NULL and site='sportsman'

SELECT distinct a.style_id,
 case a.style_id 
 
 when 123482 then 1 
 when 123497 then 2 
 when 176386 then 3 
 when 256619 then 4 
 when 249310 then 5 
 when 249309 then 6 
 when 251523 then 7 
 when 294919 then 8 
 when 280534 then 9 
 when 245235 then 10 
 when 124319 then 11 
 when 267176 then 12 
 when 123996 then 13 
 when 280296 then 14 
 when 261532 then 15 
 when 123484 then 16 
 when 280968 then 17 
 when 257032 then 18 
 when 114414 then 19 
 when 217322 then 20 
 when 271887 then 21 
 when 144257 then 22 
 when 291880 then 23 
 when 144258 then 24 
 when 271891 then 25 
 when 170101 then 26 
 when 271577 then 27 
 when 271889 then 28 
 when 251524 then 29 
 when 289232 then 30 
 when 288925 then 31 
 when 290428 then 32 
 when 290406 then 33 
 when 216713 then 34 
 when 105763 then 35 
 when 290423 then 36 
 when 20060 then 37 
 when 56296 then 38 
 when 65348 then 39 
 when 290421 then 40 
 when 288941 then 41 
 when 287552 then 42 
 when 24547 then 43 
 when 250977 then 44 
 when 22934 then 45 
 when 255121 then 46 
 when 287551 then 47 
 when 85293 then 48 
 when 264696 then 49 
 when 296692 then 50 
 when 107404 then 51 
 when 297563 then 52 
 when 225267 then 53 
 when 260690 then 54 
 when 296630 then 55 
 when 108995 then 56 
 when 266662 then 57 
 when 260689 then 58 
 when 218327 then 59 
 when 79377 then 60 
 when 135771 then 61 
 when 133339 then 62 
 when 141296 then 63 
 when 168616 then 64 
 when 249809 then 65 
 when 120896 then 66 
 when 113780 then 67 
 when 157760 then 68 
 when 247543 then 69 
 when 293450 then 70 
 when 79177 then 71 
 when 161941 then 72 
 when 145486 then 73 
 when 216883 then 74 
 when 130716 then 75 
 when 203611 then 76 
 when 202483 then 77 
 when 208723 then 78 
 when 208722 then 79 
 when 88181 then 80 
 when 84585 then 81 
 when 130717 then 82 
 when 132724 then 83 
 when 201749 then 84 
 when 138157 then 85 
 when 290638 then 86 
 when 179406 then 87 
 when 285425 then 88 
 when 106400 then 89 
 when 102771 then 90 
 when 251525 then 91 
 when 301270 then 92 
 when 172030 then 93 
 when 105625 then 94 
 when 132723 then 95 
 when 134642 then 96 
 when 134643 then 97 
 when 179405 then 98 
 when 225701 then 99 
 when 260753 then 100 
 when 260640 then 101 
 when 179407 then 102 
 when 293284 then 103 
 when 215600 then 104 
 when 106297 then 105 
 when 110381 then 106 
 when 134645 then 107 
 when 134641 then 108 
 when 134640 then 109 
 when 134644 then 110 
 when 92315 then 111 
 when 175906 then 112 
 when 290181 then 113 
 when 118883 then 114 
 when 163413 then 115 
 when 278218 then 116 
 when 80940 then 117 
 when 170100 then 118 
 when 40364 then 119 
 when 126131 then 120 
 when 134646 then 121 
 when 179408 then 122 
 when 305251 then 123 
 when 226051 then 124 
 when 20062 then 125 
 when 268637 then 126 
 when 7537 then 127 
 when 253043 then 128 
 when 251721 then 129 
 when 281617 then 130 
 when 126122 then 131 
 when 172537 then 132 
 when 208255 then 133 
 when 211797 then 134 
 when 211798 then 135 
 when 264224 then 136 
 when 305107 then 137 
 when 124206 then 138 
 when 211795 then 139 
 when 249311 then 140 
 when 249312 then 141 
 when 266661 then 142 
 when 262256 then 143 
 when 283873 then 144 
 when 110113 then 145 
 when 223181 then 146 
 when 263549 then 147 
 when 85478 then 148 
 when 302193 then 149 
 when 290404 then 150 
 when 290425 then 151 
 when 56297 then 152 
 when 212056 then 153 
 when 226010 then 154 
 when 290410 then 155 
 when 290431 then 156 
 when 290422 then 157 
 when 290420 then 158 
 when 288304 then 159 
 when 108064 then 160 
 when 201011 then 161 
 when 158521 then 162 
 when 182504 then 163 
 when 226011 then 164 
 when 290424 then 165 
 when 290417 then 166 
 when 290412 then 167 
 when 189732 then 168 
 when 125473 then 169 
 when 194077 then 170 
 when 290430 then 171 
 when 290408 then 172 
 when 170286 then 173 
 when 182505 then 174 
 when 212052 then 175 
 when 95261 then 176 
 when 166590 then 177 
 when 181558 then 178 
 when 193310 then 179 
 when 296422 then 180 
 when 264299 then 181 
 when 290418 then 182 
 when 290405 then 183 
 when 290419 then 184 
 when 290426 then 185 
 when 285602 then 186 
 when 182506 then 187 
 when 212048 then 188 
 when 192094 then 189 
 when 217689 then 190 
 when 288193 then 191 
 when 49050 then 192 
 when 212067 then 193 
 when 260751 then 194 
 when 104547 then 195 
 when 100197 then 196 
 when 281541 then 197 
 when 212060 then 198 
 when 122572 then 199 
 when 182500 then 200 
 when 200025 then 201 
 when 212055 then 202 
 when 303813 then 203 
 when 189714 then 204 
 when 49055 then 205 
 when 192093 then 206 
 when 213977 then 207 
 when 213978 then 208 
 when 289827 then 209 
 when 212051 then 210 
 when 218298 then 211 
 when 212059 then 212 
 when 290414 then 213 
 when 125806 then 214 
 when 197052 then 215 
 when 213976 then 216 
 when 266101 then 217 
 when 293016 then 218 
 when 287950 then 219 
 when 298922 then 220 
 when 167637 then 221 
 when 266657 then 222 
 when 189711 then 223 
 when 189731 then 224 
 when 253027 then 225 
 when 165142 then 226 
 when 212065 then 227 
 when 288192 then 228 
 when 247276 then 229 
 when 49016 then 230 
 when 112488 then 231 
 when 118581 then 232 
 when 200023 then 233 
 when 213979 then 234 
 when 247648 then 235 
 when 252391 then 236 
 when 281622 then 237 
 when 129037 then 238 
 when 189717 then 239 
 when 202914 then 240 
 when 188831 then 241 
 when 65289 then 242 
 when 66225 then 243 
 when 128766 then 244 
 when 116877 then 245 
 when 170287 then 246 
 when 197597 then 247 
 when 218435 then 248 
 when 268639 then 249 
 when 297395 then 250 
 when 208686 then 251 
 when 180043 then 252 
 when 246992 then 253 
 when 188829 then 254 
 when 218299 then 255 
 when 206533 then 256 
 when 215538 then 257 
 when 122751 then 258 
 when 49057 then 259 
 when 189716 then 260 
 when 198698 then 261 
 when 266696 then 262 
 when 298175 then 263 
 when 119504 then 264 
 when 247315 then 265 
 when 249746 then 266 
 when 72176 then 267 
 when 112486 then 268 
 when 132361 then 269 
 when 49014 then 270 
 when 122752 then 271 
 when 49015 then 272 
 when 181361 then 273 
 when 64013 then 274 
 when 302755 then 275 
 when 189087 then 276 
 when 260639 then 277 
 when 266660 then 278 
 when 182502 then 279 
 when 44839 then 280 
 when 247278 then 281 
 when 112487 then 282 
 when 284842 then 283 
 when 287198 then 284 
 when 163820 then 285 
 when 264807 then 286 
 when 266102 then 287 
 when 48701 then 288 
 when 82838 then 289 
 when 247275 then 290 
 when 292041 then 291 
 when 197327 then 292 
 when 287197 then 293 
 when 40312 then 294 
 when 248443 then 295 
 when 250715 then 296 
 when 194076 then 297 
 when 133073 then 298 
 when 7541 then 299 
 when 115184 then 300 
 when 251522 then 301 
 when 289383 then 302 
 when 271962 then 303 
 when 302756 then 304 
 when 274203 then 305 
 when 36607 then 306 
 when 266940 then 307 
 when 287961 then 308 
 when 44656 then 309 
 when 251706 then 310 
 when 266658 then 311 
 when 247274 then 312 
 when 264797 then 313 
 when 266049 then 314 
 when 247560 then 315 
 when 201826 then 316 
 when 159192 then 317 
 when 288583 then 318 
 when 247277 then 319 
 when 252485 then 320 
 when 262919 then 321 
 when 287930 then 322 
 when 188731 then 323 
 when 36613 then 324 
 when 168708 then 325 
 when 54043 then 326 
 when 202495 then 327 
 when 219938 then 328 
 when 302759 then 329 
 when 247286 then 330 
 when 269853 then 331 
 when 292239 then 332 
 when 113256 then 333 
 when 189907 then 334 
 when 201829 then 335 
 when 189906 then 336 
 when 58357 then 337 
 when 267275 then 338 
 when 115230 then 339 
 when 291471 then 340 
 when 291324 then 341 
 when 262938 then 342 
 when 170120 then 343 
 when 111713 then 344 
 when 113259 then 345 
 when 113258 then 346 
 when 157814 then 347 
 when 155325 then 348 
 when 262942 then 349 
 when 264445 then 350 
 when 247283 then 351 
 when 247289 then 352 
 when 48699 then 353 
 when 291366 then 354 
 when 310788 then 355 
 when 254485 then 356 
 when 24303 then 357 
 when 36610 then 358 
 when 193604 then 359 
 when 271642 then 360 
 when 297736 then 361 
 when 129072 then 362 
 when 112778 then 363 
 when 264904 then 364 
 when 301372 then 365 
 when 303610 then 366 
 when 257066 then 367 
 when 48752 then 368 
 when 131888 then 369 
 when 285285 then 370 
 when 218419 then 371 
 when 193150 then 372 
 when 155531 then 373 
 when 155707 then 374 
 when 153394 then 375 
 when 297542 then 376 
 when 247857 then 377 
 when 89710 then 378 
 when 215901 then 379 
 when 298808 then 380 
 when 24079 then 381 
 when 304769 then 382 
 when 262113 then 383 
 when 297541 then 384 
 when 262788 then 385 
 when 297550 then 386 
 when 193142 then 387 
 when 291312 then 388 
 when 304002 then 389 
 when 202494 then 390 
 when 267278 then 391 
 when 181429 then 392 
 when 255163 then 393 
 when 297389 then 394 
 when 301820 then 395 
 when 260576 then 396 
 when 75674 then 397 
 when 303333 then 398 
 when 303332 then 399 
 when 247529 then 400 
 when 281348 then 401 
 when 206299 then 402 
 when 300607 then 403 
 when 189084 then 404 
 when 277896 then 405 
 when 296903 then 406 
 when 287063 then 407 
 when 94151 then 408 
 when 46423 then 409 
 when 222538 then 410 
 when 266627 then 411 
 when 276348 then 412 
 when 248908 then 413 
 when 275743 then 414 
 when 287061 then 415 
 when 171929 then 416 
 when 260448 then 417 
 when 170618 then 418 
 when 228594 then 419 
 when 227260 then 420 
 when 256617 then 421 
 when 301243 then 422 
 when 202598 then 423 
 when 118424 then 424 
 when 309734 then 425 
 when 227189 then 426 
 when 199545 then 427 
 when 304194 then 428 
 when 251146 then 429 
 when 287491 then 430 
 when 59729 then 431 
 when 223108 then 432 
 when 216269 then 433 
 when 269260 then 434 
 when 252221 then 435 
 when 21875 then 436 
 when 46421 then 437 
 when 260979 then 438 
 when 276967 then 439 
 when 287062 then 440 
 when 287495 then 441 
 when 23379 then 442 
 when 301244 then 443 
 when 213251 then 444 
 when 289032 then 445 
 when 261975 then 446 
 when 287764 then 447 
 when 287539 then 448 
 when 287494 then 449 
 when 287546 then 450 
 when 210682 then 451 
 when 232437 then 452 
 when 268037 then 453 
 when 11649 then 454 
 when 251012 then 455 
 when 296902 then 456 
 when 216268 then 457 
 when 251738 then 458 
 when 297726 then 459 
 when 288383 then 460 
 when 294587 then 461 
 when 301253 then 462 
 when 270969 then 463 
 when 278699 then 464 
 when 159194 then 465 
 when 266288 then 466 
 when 297979 then 467 
 when 176008 then 468 
 when 250428 then 469 
 when 46420 then 470 
 when 95319 then 471 
 when 250676 then 472 
 when 267203 then 473 
 when 266716 then 474 
 when 287543 then 475 
 when 279607 then 476 
 when 297561 then 477 
 when 269400 then 478 
 when 302504 then 479 
 when 262179 then 480 
 when 307907 then 481 
 when 247280 then 482 
 when 286665 then 483 
 when 141444 then 484 
 when 262787 then 485 
 when 202719 then 486 
 when 249059 then 487 
 when 301245 then 488 
 when 266045 then 489 
 when 87653 then 490 
 when 36605 then 491 
 when 309697 then 492 
 when 193149 then 493 
 when 263480 then 494 
 when 287541 then 495 
 when 36608 then 496 
 when 44653 then 497 
 when 36606 then 498 
 when 4738 then 499 
 when 288985 then 500 
 when 193151 then 501 
 when 246964 then 502 
 when 264455 then 503 
 when 266631 then 504 
 when 271477 then 505 
 when 263396 then 506 
 when 276158 then 507 
 when 289959 then 508 
 when 36622 then 509 
 when 280138 then 510 
 when 289160 then 511 
 when 248632 then 512 
 when 128651 then 513 
 when 289114 then 514 
 when 225331 then 515 
 when 301920 then 516 
 when 36623 then 517 
 when 44657 then 518 
 when 114201 then 519 
 when 201671 then 520 
 when 289964 then 521 
 when 276159 then 522 
 when 276754 then 523 
 when 276197 then 524 
 when 281011 then 525 
 when 273434 then 526 
 when 293277 then 527 
 when 119055 then 528 
 when 306678 then 529 
 when 124215 then 530 
 when 248633 then 531 
 when 269259 then 532 
 when 88925 then 533 
 when 262116 then 534 
 when 280318 then 535 
 when 115177 then 536 
 when 115738 then 537 
 when 165385 then 538 
 when 147642 then 539 
 when 165384 then 540 
 when 303948 then 541 
 when 303097 then 542 
 when 303100 then 543 
 when 129398 then 544 
 when 147435 then 545 
 when 132722 then 546 
 when 292477 then 547 
 when 124218 then 548 
 when 302533 then 549 
 when 44655 then 550 
 when 151764 then 551 
 when 192095 then 552 
 when 192096 then 553 
 when 157750 then 554 
 when 175668 then 555 
 when 111528 then 556 
 when 200039 then 557 
 when 303947 then 558 
 when 305217 then 559 
 when 247235 then 560 
 when 264834 then 561 
 when 282123 then 562 
 when 161940 then 563 
 when 172862 then 564 
 when 183662 then 565 
 when 189733 then 566 
 when 200032 then 567 
 when 200034 then 568 
 when 277887 then 569 
 when 303607 then 570 
 when 291813 then 571 
 when 167736 then 572 
 when 211586 then 573 
 when 228154 then 574 
 when 228156 then 575 
 when 228155 then 576 
 when 282289 then 577 
 when 151774 then 578 
 when 178666 then 579 
 when 218302 then 580 
 when 218301 then 581 
 when 203607 then 582 
 when 60252 then 583 
 when 48729 then 584 
 when 48731 then 585 
 when 116735 then 586 
 when 175547 then 587 
 when 175546 then 588 
 when 170303 then 589 
 when 172696 then 590 
 when 175908 then 591 
 when 189306 then 592 
 when 192097 then 593 
 when 196786 then 594 
 when 192956 then 595 
 when 207973 then 596 
 when 205191 then 597 
 when 172651 then 598 
 when 208202 then 599 
 when 173493 then 600 
 when 218564 then 601 
 when 249743 then 602 
 when 257307 then 603 
 when 242093 then 604 
 when 286586 then 605 
 when 113783 then 606 
 when 48735 then 607 
 when 151770 then 608 
 when 193462 then 609 
 when 208724 then 610 
 when 271453 then 611 
 when 216796 then 612 
 when 247236 then 613 
 when 264838 then 614 
 when 264862 then 615 
 when 48963 then 616 
 when 111301 then 617 
 when 48977 then 618 
 when 73345 then 619 
 when 48976 then 620 
 when 151783 then 621 
 when 151778 then 622 
 when 168973 then 623 
 when 172650 then 624 
 when 167737 then 625 
 when 175075 then 626 
 when 161852 then 627 
 when 172713 then 628 
 when 172721 then 629 
 when 137051 then 630 
 when 181559 then 631 
 when 138481 then 632 
 when 181418 then 633 
 when 142883 then 634 
 when 228460 then 635 
 when 244952 then 636 
 when 251302 then 637 
 when 251299 then 638 
 when 119408 then 639 
 when 285089 then 640 
 when 73346 then 641 
 when 48962 then 642 
 when 170109 then 643 
 when 172649 then 644 
 when 178735 then 645 
 when 209475 then 646 
 when 245598 then 647 
 when 218306 then 648 
 when 48734 then 649 
 when 73343 then 650 
 when 48965 then 651 
 when 48730 then 652 
 when 73344 then 653 
 when 104706 then 654 
 when 104561 then 655 
 when 88748 then 656 
 when 74554 then 657 
 when 91942 then 658 
 when 75401 then 659 
 when 172714 then 660 
 when 148608 then 661 
 when 164782 then 662 
 when 183979 then 663 
 when 196859 then 664 
 when 189461 then 665 
 when 188820 then 666 
 when 203384 then 667 
 when 205193 then 668 
 when 203833 then 669 
 when 205188 then 670 
 when 205102 then 671 
 when 203838 then 672 
 when 208945 then 673 
 when 228461 then 674 
 when 260981 then 675 
 when 270007 then 676 
 when 285087 then 677 
 when 292848 then 678 
 when 292850 then 679 
 when 292827 then 680 
 when 294915 then 681 
 when 292853 then 682 
 when 294916 then 683 
 when 86512 then 684 
 when 48736 then 685 
 when 211572 then 686 
 when 270006 then 687 
 when 292849 then 688 
 when 218305 then 689 
 when 115142 then 690 
 when 165157 then 691 
 when 126478 then 692 
 when 175734 then 693 
 when 170781 then 694 
 when 115914 then 695 
 when 167897 then 696 
 when 205189 then 697 
 when 206272 then 698 
 when 203606 then 699 
 when 205623 then 700 
 when 163276 then 701 
 when 181133 then 702 
 when 205190 then 703 
 when 211041 then 704 
 when 215184 then 705 
 when 225703 then 706 
 when 218565 then 707 
 when 281537 then 708 
 when 285086 then 709 
 when 220720 then 710 
 when 292851 then 711 
 when 292828 then 712 
 when 292852 then 713 
 when 188815 then 714 
 when 213470 then 715 
 when 251301 then 716 
 when 155612 then 717 
 when 193052 then 718 
 when 124931 then 719 
 when 189728 then 720 
 when 198822 then 721 
 when 188828 then 722 
 when 203610 then 723 
 when 207110 then 724 
 when 227793 then 725 
 when 285091 then 726 
 when 292826 then 727 
 when 124932 then 728 
 when 278235 then 729 
 when 271458 then 730 
 when 48943 then 731 
 when 48944 then 732 
 when 181572 then 733 
 when 65291 then 734 
 when 264861 then 735 
 when 274125 then 736 
 when 297301 then 737 
 when 147840 then 738 
 when 198821 then 739 
 when 198823 then 740 
 when 205192 then 741 
 when 205746 then 742 
 when 210465 then 743 
 when 210466 then 744 
 when 217660 then 745 
 when 217659 then 746 
 when 228459 then 747 
 when 252753 then 748 
 when 254128 then 749 
 when 271974 then 750 
 when 285092 then 751 
 when 281727 then 752 
 when 285090 then 753 
 when 203616 then 754 
 when 248842 then 755 
 when 254127 then 756 
 when 286627 then 757 
 when 202309 then 758 
 when 161405 then 759 
 when 158069 then 760 
 when 169265 then 761 
 when 168439 then 762 
 when 181273 then 763 
 when 132721 then 764 
 when 161406 then 765 
 when 92767 then 766 
 when 226007 then 767 
 when 226006 then 768 
 when 123314 then 769 
 when 132720 then 770 
 when 132615 then 771 
 when 202801 then 772 
 when 201751 then 773 
 when 205624 then 774 
 when 207418 then 775 
 when 250432 then 776 
 when 250016 then 777 
 when 260583 then 778 
 when 271975 then 779 
 when 296360 then 780 
 when 200036 then 781 
 when 262208 then 782 
 when 297719 then 783 
 when 307193 then 784 
 when 261970 then 785 
 when 264461 then 786 
 when 264459 then 787 
 when 282870 then 788 
 when 99082 then 789 
 when 200042 then 790 
 when 210192 then 791 
 when 207419 then 792 
 when 210190 then 793 
 when 247260 then 794 
 when 247284 then 795 
 when 255630 then 796 
 when 261523 then 797 
 when 263839 then 798 
 when 263845 then 799 
 when 273262 then 800 
 when 263847 then 801 
 when 286628 then 802 
 when 281324 then 803 
 when 282715 then 804 
 when 288590 then 805 
 when 297888 then 806 
 when 296409 then 807 
 when 296410 then 808 
 when 200043 then 809 
 when 214089 then 810 
 when 249817 then 811 
 when 92765 then 812 
 when 65290 then 813 
 when 175669 then 814 
 when 175907 then 815 
 when 209486 then 816 
 when 216708 then 817 
 when 157751 then 818 
 when 189726 then 819 
 when 302196 then 820 
 when 276303 then 821 
 when 202605 then 822 
 when 123330 then 823 
 when 120350 then 824 
 when 199529 then 825 
 when 126271 then 826 
 when 172033 then 827 
 when 200038 then 828 
 when 201756 then 829 
 when 195991 then 830 
 when 292469 then 831 
 when 302518 then 832 
 when 249056 then 833 
 when 245817 then 834 
 when 247869 then 835 
 when 207417 then 836 
 when 247279 then 837 
 when 267979 then 838 
 when 272173 then 839 
 when 276186 then 840 
 when 273263 then 841 
 when 276640 then 842 
 when 292823 then 843 
 when 290017 then 844 
 when 297251 then 845 
 when 297252 then 846 
 when 296408 then 847 
 when 247287 then 848 
 when 276183 then 849 
 when 147895 then 850 
 when 283677 then 851 
 when 292824 then 852 
 when 271459 then 853 
 when 48996 then 854 
 when 49002 then 855 
 when 48995 then 856 
 when 151004 then 857 
 when 184447 then 858 
 when 49005 then 859 
 when 217661 then 860 
 when 247727 then 861 
 when 247705 then 862 
 when 247723 then 863 
 when 247711 then 864 
 when 285770 then 865 
 when 285523 then 866 
 when 204173 then 867 
 when 271451 then 868 
 when 247628 then 869 
 when 247625 then 870 
 when 66435 then 871 
 when 76932 then 872 
 when 269823 then 873 
 when 248677 then 874 
 when 78739 then 875 
 when 48997 then 876 
 when 49011 then 877 
 when 175446 then 878 
 when 200033 then 879 
 when 218307 then 880 
 when 228505 then 881 
 when 287291 then 882 
 when 143481 then 883 
 when 218300 then 884 
 when 247322 then 885 
 when 247281 then 886 
 when 292822 then 887 
 when 210620 then 888 
 when 172913 then 889 
 when 287915 then 890 
 when 272113 then 891 
 when 305060 then 892 
 when 67721 then 893 
 when 49004 then 894 
 when 49009 then 895 
 when 220419 then 896 
 when 203617 then 897 
 when 246983 then 898 
 when 247588 then 899 
 when 170285 then 900 
 when 279962 then 901 
 when 280852 then 902 
 when 277876 then 903 
 when 281743 then 904 
 when 281167 then 905 
 when 282180 then 906 
 when 296907 then 907 
 when 307754 then 908 
 when 247589 then 909 
 when 283964 then 910 
 when 247749 then 911 
 when 134637 then 912 
 when 134639 then 913 
 when 134638 then 914 
 when 138138 then 915 
 when 148914 then 916 
 when 147434 then 917 
 when 128458 then 918 
 when 247697 then 919 
 when 277893 then 920 
 when 290724 then 921 
 when 285774 then 922 
 when 285803 then 923 
 when 307695 then 924 
 when 305081 then 925 
 when 305647 then 926 
 when 203515 then 927 
 when 286467 then 928 
 when 200041 then 929 
 when 201496 then 930 
 when 218303 then 931 
 when 172796 then 932 
 when 193074 then 933 
 when 203603 then 934 
 when 173255 then 935 
 when 67720 then 936 
 when 247590 then 937 
 when 122915 then 938 
 when 122758 then 939 
 when 268401 then 940 
 when 268403 then 941 
 when 268402 then 942 
 when 281400 then 943 
 when 285347 then 944 
 when 196395 then 945 
 when 290746 then 946 
 when 255660 then 947 
 when 285379 then 948 
 when 285428 then 949 
 when 307693 then 950 
 when 175123 then 951 
 when 282120 then 952 
 when 145195 then 953 
 when 218304 then 954 
 when 269847 then 955 
 when 209482 then 956 
 when 200035 then 957 
 when 218308 then 958 
 when 250183 then 959 
 when 264909 then 960 
 when 48945 then 961 
 when 7579 then 962 
 when 189734 then 963 
 when 204789 then 964 
 when 189361 then 965 
 when 246986 then 966 
 when 48987 then 967 
 when 122917 then 968 
 when 264913 then 969 
 when 280862 then 970 
 when 285430 then 971 
 when 281374 then 972 
 when 290758 then 973 
 when 294951 then 974 
 when 297394 then 975 
 when 307894 then 976 
 when 301150 then 977 
 when 305586 then 978 
 when 305028 then 979 
 when 157986 then 980 
 when 280846 then 981 
 when 247862 then 982 
 when 297863 then 983 
 when 296690 then 984 
 when 266527 then 985 
 when 148141 then 986 
 when 109580 then 987 
 when 179413 then 988 
 when 209125 then 989 
 when 222775 then 990 
 when 150848 then 991 
 when 242415 then 992 
 when 246987 then 993 
 when 178870 then 994 
 when 49007 then 995 
 when 170677 then 996 
 when 72185 then 997 
 when 122759 then 998 
 when 268399 then 999 
 when 267813 then 1000 
 else 1000 
 
 end as ranking,
 
 
 
 max(a.non_invt) as non_invt,sum(qoh + qc) as available,max(a.dept) as dept,max(a.brand) as brand,max(a.of3) as of3,case when sum(qoh + qc) > 0 then 1 else 0 end as instock
 FROM web_all_products a WITH (NOLOCK)
 INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
 INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id and c.store_id=10)
 INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
 INNER JOIN dbo.tb_styles qq WITH (NOLOCK) ON (qq.style_id = a.style_id)
 where a.style_id in (123482,123497,176386,256619,249310,249309,251523,294919,280534,245235,124319,267176,123996,280296,261532,123484,280968,257032,114414,217322,271887,144257,291880,144258,271891,170101,271577,271889,251524,289232,288925,290428,290406,216713,105763,290423,20060,56296,65348,290421,288941,287552,24547,250977,22934,255121,287551,85293,264696,296692,107404,297563,225267,260690,296630,108995,266662,260689,218327,79377,135771,133339,141296,168616,249809,120896,113780,157760,247543,293450,79177,161941,145486,216883,130716,203611,202483,208723,208722,88181,84585,130717,132724,201749,138157,290638,179406,285425,106400,102771,251525,301270,172030,105625,132723,134642,134643,179405,225701,260753,260640,179407,293284,215600,106297,110381,134645,134641,134640,134644,92315,175906,290181,118883,163413,278218,80940,170100,40364,126131,134646,179408,305251,226051,20062,268637,7537,253043,251721,281617,126122,172537,208255,211797,211798,264224,305107,124206,211795,249311,249312,266661,262256,283873,110113,223181,263549,85478,302193,290404,290425,56297,212056,226010,290410,290431,290422,290420,288304,108064,201011,158521,182504,226011,290424,290417,290412,189732,125473,194077,290430,290408,170286,182505,212052,95261,166590,181558,193310,296422,264299,290418,290405,290419,290426,285602,182506,212048,192094,217689,288193,49050,212067,260751,104547,100197,281541,212060,122572,182500,200025,212055,303813,189714,49055,192093,213977,213978,289827,212051,218298,212059,290414,125806,197052,213976,266101,293016,287950,298922,167637,266657,189711,189731,253027,165142,212065,288192,247276,49016,112488,118581,200023,213979,247648,252391,281622,129037,189717,202914,188831,65289,66225,128766,116877,170287,197597,218435,268639,297395,208686,180043,246992,188829,218299,206533,215538,122751,49057,189716,198698,266696,298175,119504,247315,249746,72176,112486,132361,49014,122752,49015,181361,64013,302755,189087,260639,266660,182502,44839,247278,112487,284842,287198,163820,264807,266102,48701,82838,247275,292041,197327,287197,40312,248443,250715,194076,133073,7541,115184,251522,289383,271962,302756,274203,36607,266940,287961,44656,251706,266658,247274,264797,266049,247560,201826,159192,288583,247277,252485,262919,287930,188731,36613,168708,54043,202495,219938,302759,247286,269853,292239,113256,189907,201829,189906,58357,267275,115230,291471,291324,262938,170120,111713,113259,113258,157814,155325,262942,264445,247283,247289,48699,291366,310788,254485,24303,36610,193604,271642,297736,129072,112778,264904,301372,303610,257066,48752,131888,285285,218419,193150,155531,155707,153394,297542,247857,89710,215901,298808,24079,304769,262113,297541,262788,297550,193142,291312,304002,202494,267278,181429,255163,297389,301820,260576,75674,303333,303332,247529,281348,206299,300607,189084,277896,296903,287063,94151,46423,222538,266627,276348,248908,275743,287061,171929,260448,170618,228594,227260,256617,301243,202598,118424,309734,227189,199545,304194,251146,287491,59729,223108,216269,269260,252221,21875,46421,260979,276967,287062,287495,23379,301244,213251,289032,261975,287764,287539,287494,287546,210682,232437,268037,11649,251012,296902,216268,251738,297726,288383,294587,301253,270969,278699,159194,266288,297979,176008,250428,46420,95319,250676,267203,266716,287543,279607,297561,269400,302504,262179,307907,247280,286665,141444,262787,202719,249059,301245,266045,87653,36605,309697,193149,263480,287541,36608,44653,36606,4738,288985,193151,246964,264455,266631,271477,263396,276158,289959,36622,280138,289160,248632,128651,289114,225331,301920,36623,44657,114201,201671,289964,276159,276754,276197,281011,273434,293277,119055,306678,124215,248633,269259,88925,262116,280318,115177,115738,165385,147642,165384,303948,303097,303100,129398,147435,132722,292477,124218,302533,44655,151764,192095,192096,157750,175668,111528,200039,303947,305217,247235,264834,282123,161940,172862,183662,189733,200032,200034,277887,303607,291813,167736,211586,228154,228156,228155,282289,151774,178666,218302,218301,203607,60252,48729,48731,116735,175547,175546,170303,172696,175908,189306,192097,196786,192956,207973,205191,172651,208202,173493,218564,249743,257307,242093,286586,113783,48735,151770,193462,208724,271453,216796,247236,264838,264862,48963,111301,48977,73345,48976,151783,151778,168973,172650,167737,175075,161852,172713,172721,137051,181559,138481,181418,142883,228460,244952,251302,251299,119408,285089,73346,48962,170109,172649,178735,209475,245598,218306,48734,73343,48965,48730,73344,104706,104561,88748,74554,91942,75401,172714,148608,164782,183979,196859,189461,188820,203384,205193,203833,205188,205102,203838,208945,228461,260981,270007,285087,292848,292850,292827,294915,292853,294916,86512,48736,211572,270006,292849,218305,115142,165157,126478,175734,170781,115914,167897,205189,206272,203606,205623,163276,181133,205190,211041,215184,225703,218565,281537,285086,220720,292851,292828,292852,188815,213470,251301,155612,193052,124931,189728,198822,188828,203610,207110,227793,285091,292826,124932,278235,271458,48943,48944,181572,65291,264861,274125,297301,147840,198821,198823,205192,205746,210465,210466,217660,217659,228459,252753,254128,271974,285092,281727,285090,203616,248842,254127,286627,202309,161405,158069,169265,168439,181273,132721,161406,92767,226007,226006,123314,132720,132615,202801,201751,205624,207418,250432,250016,260583,271975,296360,200036,262208,297719,307193,261970,264461,264459,282870,99082,200042,210192,207419,210190,247260,247284,255630,261523,263839,263845,273262,263847,286628,281324,282715,288590,297888,296409,296410,200043,214089,249817,92765,65290,175669,175907,209486,216708,157751,189726,302196,276303,202605,123330,120350,199529,126271,172033,200038,201756,195991,292469,302518,249056,245817,247869,207417,247279,267979,272173,276186,273263,276640,292823,290017,297251,297252,296408,247287,276183,147895,283677,292824,271459,48996,49002,48995,151004,184447,49005,217661,247727,247705,247723,247711,285770,285523,204173,271451,247628,247625,66435,76932,269823,248677,78739,48997,49011,175446,200033,218307,228505,287291,143481,218300,247322,247281,292822,210620,172913,287915,272113,305060,67721,49004,49009,220419,203617,246983,247588,170285,279962,280852,277876,281743,281167,282180,296907,307754,247589,283964,247749,134637,134639,134638,138138,148914,147434,128458,247697,277893,290724,285774,285803,307695,305081,305647,203515,286467,200041,201496,218303,172796,193074,203603,173255,67720,247590,122915,122758,268401,268403,268402,281400,285347,196395,290746,255660,285379,285428,307693,175123,282120,145195,218304,269847,209482,200035,218308,250183,264909,48945,7579,189734,204789,189361,246986,48987,122917,264913,280862,285430,281374,290758,294951,297394,307894,301150,305586,305028,157986,280846,247862,297863,296690,266527,148141,109580,179413,209125,222775,150848,242415,246987,178870,49007,170677,72185,122759,268399,267813)
 
 
  and ltrim(rtrim(lower(a.dept))) = 'law enforcement'
 
	and a.of3='9 MM'
	
 group by a.style_id 
  order by  instock desc, ranking asc

select distinct dept from mysearch where dept <> 'EMPTY'
  order by dept asc

select distinct brand from mysearch
  order by brand asc

select distinct of3 from mysearch
  order by of3 asc

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =266102 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=266102 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 266102 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 266102 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:20:49' and
end_date >= 'May 20, 2024 15:20:49'
and store_id=10 and style_id=266102

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 266102 
and (a.start_date<= 'May 20, 2024 15:20:49' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:20:49'
order by a.promo_id desc

select * from tb_product_reviews 
												where style_id=266102  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=266102
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =271962 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=271962 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 271962 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 271962 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:20:49' and
end_date >= 'May 20, 2024 15:20:49'
and store_id=10 and style_id=271962

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 271962 
and (a.start_date<= 'May 20, 2024 15:20:49' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:20:49'
order by a.promo_id desc

select * from tb_product_reviews 
												where style_id=271962  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=271962
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =269853 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=269853 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 269853 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 269853 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:20:49' and
end_date >= 'May 20, 2024 15:20:49'
and store_id=10 and style_id=269853

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 269853 
and (a.start_date<= 'May 20, 2024 15:20:49' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:20:49'
order by a.promo_id desc

select * from tb_product_reviews 
												where style_id=269853  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=269853
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =264909 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=264909 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 264909 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 264909 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:20:49' and
end_date >= 'May 20, 2024 15:20:49'
and store_id=10 and style_id=264909

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 264909 
and (a.start_date<= 'May 20, 2024 15:20:49' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:20:49'
order by a.promo_id desc

select * from tb_product_reviews 
												where style_id=264909  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=264909
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =189084 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=189084 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 189084 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 189084 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

select * from tb_product_reviews 
												where style_id=189084  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=189084
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =252221 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=252221 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 252221 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 252221 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

select * from tb_product_reviews 
												where style_id=252221  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=252221
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =251012 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=251012 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 251012 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 251012 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

select * from tb_product_reviews 
												where style_id=251012  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=251012
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =250676 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=250676 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 250676 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 250676 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

select * from tb_product_reviews 
												where style_id=250676  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=250676
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =115142 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=115142 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 115142 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 115142 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

select * from tb_product_reviews 
												where style_id=115142  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=115142
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =172033 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=172033 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 172033 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 172033 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

select * from tb_product_reviews 
												where style_id=172033  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=172033
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =49004 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=49004 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 49004 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 49004 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

select * from tb_product_reviews 
												where style_id=49004  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=49004
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =49009 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=49009 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 49009 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 49009 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

select * from tb_product_reviews 
												where style_id=49009  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=49009
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =250183 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=250183 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 250183 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 250183 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

select * from tb_product_reviews 
												where style_id=250183  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=250183
												and status='A' 
												and site = 'sportsman'

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\inetpub\feeds\
forumemail=info@sportsmansoutdoorsuperstore.com
forumtitle=Sportsmans Outdoor Superstore
giftcardimgpath=file:///C:/websites/images/
giftcardpdfpath=E:\websites\giftcardPDF\
googlefeedproducttype=
homeurl=https://www.sportsmansoutdoorsuperstore.com/
hostedpagelink=https://transaction.hostedpayments.com/
iconurl=https://www.sportsmansoutdoorsuperstore.com/images/icons/
imagedir=E:\inetpub\images\
logdir=E:\inetpub\logs
metadesc=
metatags=
mydomain=https://www.sportsmansoutdoorsuperstore.com/
pagetitle=
picurl=https://www.sportsmansoutdoorsuperstore.com/images/
prodimgdir=E:\inetpub\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
qoh_store=10
safety_stock=0
salesemail=sales@sportsmansoutdoorsuperstore.com
secureurl=https://www.sportsmansoutdoorsuperstore.com/
site=sportsman
tempmailport=25
tempmailserver=127.0.0.1
tokenurl=https://services.elementexpress.com/express.asmx
use_multi_buy=OFF
vantivurl=https://transaction.elementexpress.com/express.asmx
webadminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/
websitename=Sportsmans Outdoor Superstore

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\search.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=fikker-2ITi-jkXI=4enQXwhGlJjmPkfWL9j3di8QM5h9hgJJ
HTTP_HOST=www.sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/search.cfm/kword/HK%20MP5%2022/of3/9-mm/dept/law%20enforcement
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.200.30.6
PATH_INFO=/kword/HK MP5 22/of3/9-mm/dept/law enforcement
PATH_TRANSLATED=E:\inetpub\wwwroot\search.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/search.cfm
SERVER_NAME=www.sportsmansoutdoorsuperstore.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=14602
cftoken=a280288e6b6f66ec-EA7E2ACD-B311-F9D0-BFEB249EAE0977AE
hitcount=1
lastvisit={ts '2024-05-20 15:20:48'}
timecreated={ts '2024-05-20 15:20:48'}
urltoken=CFID=14602&CFTOKEN=a280288e6b6f66ec-EA7E2ACD-B311-F9D0-BFEB249EAE0977AE

Cookie Variables:
CFID=14602
CFTOKEN=a280288e6b6f66ec-EA7E2ACD-B311-F9D0-BFEB249EAE0977AE
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
USERNAME=
fikker-2ITi-jkXI=4enQXwhGlJjmPkfWL9j3di8QM5h9hgJJ

Form Fields:
KWORD=HK MP5 22
RETURN_TO_PAGE=null

Request Parameters:
samesite_value=

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
cfid=14602
cftoken=a280288e6b6f66ec-EA7E2ACD-B311-F9D0-BFEB249EAE0977AE
cs=/index.cfm
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOS_14602_a280288e6b6f66ec-EA7E2ACD-B311-F9D0-BFEB249EAE0977AE
strarray=Array (0)
urltoken=CFID=14602&CFTOKEN=a280288e6b6f66ec-EA7E2ACD-B311-F9D0-BFEB249EAE0977AE

URL Parameters:
BRAND=
CLEARANCE=
DISPLAYCOUNT=18
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF4=
OF5=
OF6=
ORDER_BY=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SPORTSMAN=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
TYP=
WHATSNEW=
dept=law enforcement
kword=HK MP5 22
of3=9-mm